﻿CREATE PROCEDURE [acms].[Template_GetAllByParentTemplateId]
	@ParentTemplateId int
AS
	SELECT a.*
	From Template_View a
		inner join [TemplateHierarchy_View] b on a.Id = b.ChildId
	Where b.ParentId = @ParentTemplateId
	order by b.Sequence
RETURN 0;